How to: Open an existing table in Datasheet view to type data.
Solution:
Select the table in the Database window, and click 'Open'.
1) If the Database window is not active, activate the Database window.
2) Click the 'Tables' tab in the Database window.
Tables tab
3) Select the table to open from the list.
4) Click 'Open'. (The table opens in Datasheet view.)
5) Type or edit the desired data.
6) To save changes, select the 'File' menu and select 'Save Layout'.
NOTE: Data typed in the field is saved automatically when moving to the next record. Saving the layout saves any changes made to the layout.
7) To close the table datasheet, select the 'File' menu and select 'Close'. (The table closes, and changes are saved.)